kok
Tables (6)
tbl_company_post_alert
- id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
- member_id — bigint unsigned not null
- member_id (id2) — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL
tbl_file
- id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
- file_origint_name — varchar(255) not null
- file_name — varchar(255) not null
- file_path — varchar(255) not null
- file_size — varchar(255) not null
- file_content_type — varchar(255) not null
- created_datetime — datetime default current_timestamp
- updated_datetime — datetime default current_timestamp
tbl_member
- id — unsigned auto_increment primary key — Primary key — NOT NULL
- member_name — varchar(255) not null
- member_phone — varchar(255) not null
- member_email — varchar(255) not null unique
- member_password — varchar(255) not null
- member_job — varchar(255)
- member_intro — text
- member_role — enum('member', 'admin') not null default 'member'
- member_provider — enum('google', 'naver', 'kakao', 'kok') default 'kok'
- member_last_login_date — datetime
- member_status — enum('active','inactive') default 'active' not null
- created_datetime — datetime default current_timestamp
- updated_datetime — datetime default current_timestamp
tbl_member_background_file
- id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
- file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
- member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL
tbl_member_profile_file
- id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
- file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
- member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL
tbl_member_storage_file
- id — bigint unsigned auto_increment primary key — Primary key — NOT NULL
- file_id — bigint unsigned not null — Foreign key → tbl_file.id — NOT NULL
- member_id — bigint unsigned not null — Foreign key → tbl_member.id — NOT NULL