ㄹ

Tables (18)

branch

  • branch_id — bigint — Primary key — NOT NULL
  • branch_latitude — double — NOT NULL
  • branch_longitude — double — NOT NULL
  • branch_address — varchar(255) — NOT NULL
  • branch_name — varchar(255) — NOT NULL
  • branch_phone_number — varchar(255)
  • road_from_station — varchar(255)

branch_image

  • image_id — bigint — Foreign key → image.image_id — NOT NULL
  • branch_id — bigint — Foreign key → branch.branch_id

comment

  • id — bigint — Primary key — NOT NULL — 댓글 ID
  • content — varchar(255) — NOT NULL — 댓글 내용
  • created_date — datetime
  • last_modified_date — datetime — 수정 일시
  • member_id — bigint — Foreign key → member.member_id — 회원 ID
  • post_id — bigint — Foreign key → post.id — 게시글 ID

company

  • company_id — bigint — Primary key — NOT NULL
  • company_head_count — int
  • contract_end_date — date — NOT NULL
  • contract_start_date — date — NOT NULL
  • business_type — varchar(255) — NOT NULL
  • company_email_domain — varchar(255) — NOT NULL
  • company_name — varchar(255) — NOT NULL
  • contract_manager_contact — varchar(255) — NOT NULL
  • contract_manager_name — varchar(255) — NOT NULL
  • representative_contact — varchar(255) — NOT NULL
  • representative_name — varchar(255) — NOT NULL

image

  • image_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • dtype — varchar(31) — NOT NULL
  • image_url — varchar(255) — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • member_delete_check — bit(1) — NOT NULL
  • member_sms_agree — bit(1) — NOT NULL
  • company_id — bigint — Foreign key → company.company_id
  • created_date — datetime
  • image_id — bigint — Foreign key → member_image.image_id
  • last_modified_date — datetime
  • member_email — varchar(255) — NOT NULL
  • member_name — varchar(255) — NOT NULL
  • member_nickname — varchar(255) — NOT NULL
  • member_phone — varchar(255) — NOT NULL
  • member_pw — varchar(255) — NOT NULL
  • member_job — enum('OWNER','OFFICE','FINANCE','HRD','PROMOTION','ITDEV','ITPLAN','SALE','DESIGN','SERVICE','CONTENTS','RND','PROFESSIONAL','MD','INSURANCE','ETC')
  • member_role — enum('ROLE_USER','ROLE_ADMIN')

member_image

  • image_id — bigint — Foreign key → image.image_id — NOT NULL

member_reservation

  • member_reservation_id — bigint — Primary key — NOT NULL
  • member_reservation_status — enum('WAITING','ACCEPTED','REJECTED','CANCELED')
  • member_reservation_type — enum('REPRESENTATIVE','PARTICIPANT')
  • member_id — bigint — Foreign key → member.member_id
  • reservation_id — bigint — Foreign key → reservation.reservation_id

notification

  • id — bigint — Primary key — NOT NULL — 알림 ID
  • image — varchar(255)
  • title — varchar(50) — NOT NULL — 알림 제목
  • content — varchar(255) — NOT NULL — 알림 내용
  • target_id — bigint — NOT NULL — 알림 대상 ID
  • type — varchar(50) — NOT NULL — 알림 타입
  • created_date — datetime — 생성 일시
  • last_modified_date — datetime — 수정 일시
  • member_id — bigint — Foreign key → member.member_id — NOT NULL — 회원 ID

post

  • id — bigint — Primary key — NOT NULL — 게시글 ID
  • category — enum('JOB', 'OWNER', 'OFFICE', 'FINANCE', 'HRD', 'PROMOTION', 'ITDEV', 'ITPLAN', 'SALE', 'DESIGN', 'SERVICE', 'CONTENTS', 'RND', 'PROFESSIONAL', 'MD', 'INSURANCE', 'ETC', 'INTEREST', 'FREE_BOARD', 'COMPANY_LIFE', 'INVESTMENT_FINANCE', 'STUDY_PROMOTION', 'EXERCISE', 'FOOD', 'CULTURAL_LIFE', 'FAMILY_PET')
  • tag — enum('FREE', 'INTERVIEW', 'CAREER', 'INSIGHT', 'QUESTION', 'CHAT', 'INFO', 'BRAG')
  • title — varchar(255) — NOT NULL — 게시글 제목
  • content — varchar(255) — NOT NULL — 게시글 내용
  • view_count — int — NOT NULL — 조회수
  • like_count — int — NOT NULL — 좋아요 수
  • comment_count — int — NOT NULL — 댓글 수
  • created_date — datetime — 생성 일시
  • last_modified_date — datetime — 수정 일시
  • member_id — bigint — Foreign key → member.member_id — 회원 ID

post_image

  • image_id — bigint — Foreign key → image.image_id — NOT NULL
  • post_id — bigint — Foreign key → post.id

post_like

  • post_id — bigint — Primary key — NOT NULL — 게시글 아이디
  • member_email — varchar(255) — Primary key — NOT NULL — 회원 이메일

private_post

  • private_post_id — bigint — Primary key — NOT NULL
  • private_post_title — varchar(50) — NOT NULL
  • private_post_content — varchar(500) — NOT NULL
  • created_date — datetime
  • last_modified_date — datetime
  • member_id — bigint — Foreign key → member.member_id
  • branch_id — bigint — Foreign key → branch.branch_id
  • private_post_answer_id — bigint — Foreign key → private_post_answer.private_post_answer_id

private_post_answer

  • private_post_answer_id — bigint — Primary key — NOT NULL
  • private_post_answer_content — varchar(500) — NOT NULL
  • created_date — datetime
  • last_modified_date — datetime

reservation

  • reservation_id — bigint — Primary key — NOT NULL
  • created_date — datetime
  • last_modified_date — datetime
  • reservation_end_date_time — datetime
  • reservation_start_date_time — datetime
  • space_id — bigint — Foreign key → space.space_id
  • reservation_name — varchar(255) — NOT NULL

space

  • space_id — bigint — Primary key — NOT NULL
  • can_video_conference — bit(1)
  • is_private — bit(1)
  • meeting_room_capacity — int
  • projector_exists — bit(1)
  • space_floor — int — NOT NULL
  • branch_id — bigint — Foreign key → branch.branch_id
  • dtype — varchar(31) — NOT NULL
  • space_name — varchar(255) — NOT NULL
  • meeting_room_type — enum('MINI','STANDARD','MEDIUM','STATE')
  • focus_desk_number — int
  • can_reserve — bit(1)

space_image

  • image_id — bigint — Foreign key → image.image_id — NOT NULL
  • space_id — bigint — Foreign key → space.space_id

station_names

  • branch_id — bigint — Foreign key → branch.branch_id — NOT NULL
  • station_to_branch — varchar(255)